﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 提现记录实体类：fanli_getMoneyList 。
	/// </summary>
	[Serializable]
	public class fanli_getMoneyList
	{
		public fanli_getMoneyList()
		{}

		#region Model
		private int _id; //id
		private int _userid; //用户id
		private float _money; //提现金额
		private DateTime? _applyTime; //提现申请时间
		private string _applyIp; //申请ip
		private DateTime? _confirmDate; //提现确认时间
		private int _adminID; //提现审核人
		private int _status; //提现状态
		private string _methord; //提现方式
		private string _bankType; //提现银行
		private string _bankAccount; //提现账号
		private string _realname; //提现姓名
		private string _memo; //备注
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 用户id
		/// </summary>
		public int userid
		{
			set{ _userid=value;}
			get{return _userid;}
		}
        /// <summary>
		/// 提现金额
		/// </summary>
		public float money
		{
			set{ _money=value;}
			get{return _money;}
		}
        /// <summary>
		/// 提现申请时间
		/// </summary>
		public DateTime? applyTime
		{
			set{ _applyTime=value;}
			get{return _applyTime;}
		}
        /// <summary>
		/// 申请ip
		/// </summary>
		public string applyIp
		{
			set{ _applyIp=value;}
			get{return _applyIp;}
		}
        /// <summary>
		/// 提现确认时间
		/// </summary>
		public DateTime? confirmDate
		{
			set{ _confirmDate=value;}
			get{return _confirmDate;}
		}
        /// <summary>
		/// 提现审核人
		/// </summary>
		public int adminID
		{
			set{ _adminID=value;}
			get{return _adminID;}
		}
        /// <summary>
		/// 提现状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 提现方式
		/// </summary>
		public string methord
		{
			set{ _methord=value;}
			get{return _methord;}
		}
        /// <summary>
		/// 提现银行
		/// </summary>
		public string bankType
		{
			set{ _bankType=value;}
			get{return _bankType;}
		}
        /// <summary>
		/// 提现账号
		/// </summary>
		public string bankAccount
		{
			set{ _bankAccount=value;}
			get{return _bankAccount;}
		}
        /// <summary>
		/// 提现姓名
		/// </summary>
		public string realname
		{
			set{ _realname=value;}
			get{return _realname;}
		}
        /// <summary>
		/// 备注
		/// </summary>
		public string memo
		{
			set{ _memo=value;}
			get{return _memo;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
提现记录,getMoneyList
id,用户id,提现金额,提现申请时间,申请ip,提现确认时间,提现审核人,提现状态,提现方式,提现银行,提现账号,提现姓名,备注,扩展1,扩展2
id,userid,money,applyTime,applyIp,confirmDate,adminID,status,methord,bankType,bankAccount,realname,memo,ext1,ext2
i,i,f,d,c20,d,i,i,c20,c20,c256,c20,c400,c100,c100



--------------------------
-- 创建表[提现记录]开始: 
-- alter table  [fanli_getMoneyList] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_getMoneyList') drop table fanli_getMoneyList
  CREATE TABLE [fanli_getMoneyList] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [userid] int,
	 [money] [float],
	 [applyTime] [datetime],
	 [applyIp] [varchar] (20),
	 [confirmDate] [datetime],
	 [adminID] int,
	 [status] int,
	 [methord] [varchar] (20),
	 [bankType] [varchar] (20),
	 [bankAccount] [varchar] (256),
	 [realname] [varchar] (20),
	 [memo] [varchar] (400),
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'提现记录 ',N'user',N'dbo',N'table',N'fanli_getMoneyList', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'用户id',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'userid'
 exec sp_addextendedproperty N'MS_Description',N'提现金额',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'money'
 exec sp_addextendedproperty N'MS_Description',N'提现申请时间',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'applyTime'
 exec sp_addextendedproperty N'MS_Description',N'申请ip',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'applyIp'
 exec sp_addextendedproperty N'MS_Description',N'提现确认时间',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'confirmDate'
 exec sp_addextendedproperty N'MS_Description',N'提现审核人',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'adminID'
 exec sp_addextendedproperty N'MS_Description',N'提现状态',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'提现方式',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'methord'
 exec sp_addextendedproperty N'MS_Description',N'提现银行',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'bankType'
 exec sp_addextendedproperty N'MS_Description',N'提现账号',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'bankAccount'
 exec sp_addextendedproperty N'MS_Description',N'提现姓名',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'realname'
 exec sp_addextendedproperty N'MS_Description',N'备注',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'memo'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_getMoneyList',N'column',N'ext2'

-- 创建表[提现记录]结束。 
--------------------------

		*/
		#endregion document
	}
}

